Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 17000 |
| Missing cells | 856 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 3 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 3.2 MiB |
| Average record size in memory | 200.0 B |
Variable types
| NUM | 13 |
|---|---|
| CAT | 11 |
| BOOL | 1 |
| Dataset has 3 (< 0.1%) duplicate rows | Duplicates |
Hotel_Address has a high cardinality: 1365 distinct values | High cardinality |
Review_Date has a high cardinality: 731 distinct values | High cardinality |
Hotel_Name has a high cardinality: 1364 distinct values | High cardinality |
Negative_Review has a high cardinality: 11586 distinct values | High cardinality |
Positive_Review has a high cardinality: 14193 distinct values | High cardinality |
Tags has a high cardinality: 7413 distinct values | High cardinality |
days_since_review has a high cardinality: 731 distinct values | High cardinality |
Review has a high cardinality: 16727 distinct values | High cardinality |
Travel_type has 556 (3.3%) missing values | Missing |
Reviewer_Nationality is uniformly distributed | Uniform |
Review is uniformly distributed | Uniform |
Review_Total_Negative_Word_Counts has 4270 (25.1%) zeros | Zeros |
Review_Total_Positive_Word_Counts has 1350 (7.9%) zeros | Zeros |
Review_sent has 3948 (23.2%) zeros | Zeros |
Positive_Review_sent has 456 (2.7%) zeros | Zeros |
Negative_Review_sent has 705 (4.1%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-07 13:22:39.695815 |
|---|---|
| Analysis finished | 2020-12-07 13:23:13.953490 |
| Duration | 34.26 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 1365 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| 27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom | 88 |
|---|---|
| Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom | 85 |
| 225 Edgware Road Westminster Borough London W2 1JU United Kingdom | 83 |
| 372 Strand Westminster Borough London WC2R 0JJ United Kingdom | 76 |
| Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom | 75 |
| Other values (1360) |
| Value | Count | Frequency (%) | |
| 27 Devonshire Terrace Westminster Borough London W2 3DP United Kingdom | 88 | 0.5% | |
| Scarsdale Place Kensington Kensington and Chelsea London W8 5SY United Kingdom | 85 | 0.5% | |
| 225 Edgware Road Westminster Borough London W2 1JU United Kingdom | 83 | 0.5% | |
| 372 Strand Westminster Borough London WC2R 0JJ United Kingdom | 76 | 0.4% | |
| Great Cumberland Place Westminster Borough London W1H 7DL United Kingdom | 75 | 0.4% | |
| 30 Leinster Gardens Bayswater Westminster Borough London W2 3AN United Kingdom | 73 | 0.4% | |
| 163 Marsh Wall Docklands Tower Hamlets London E14 9SJ United Kingdom | 67 | 0.4% | |
| Piazza Duca D Aosta 4 6 Central Station 20124 Milan Italy | 66 | 0.4% | |
| Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands | 66 | 0.4% | |
| Bryanston Street Marble Arch Westminster Borough London W1H 7EH United Kingdom | 65 | 0.4% | |
| Other values (1355) | 16256 | 95.6% |
Unique
| Unique | 85 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 96 |
|---|---|
| Median length | 57 |
| Mean length | 58.11417647 |
| Min length | 34 |
Additional_Number_of_Scoring
Real number (ℝ≥0)
| Distinct | 469 |
|---|---|
| Distinct (%) | 2.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 381.1751176 |
|---|---|
| Minimum | 5 |
| Maximum | 2682 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 49 |
| Q1 | 129 |
| median | 256 |
| Q3 | 482 |
| 95-th percentile | 1190 |
| Maximum | 2682 |
| Range | 2677 |
| Interquartile range (IQR) | 353 |
Descriptive statistics
| Standard deviation | 383.7724891 |
|---|---|
| Coefficient of variation (CV) | 1.006814116 |
| Kurtosis | 8.43356199 |
| Mean | 381.1751176 |
| Median Absolute Deviation (MAD) | 151 |
| Skewness | 2.472178131 |
| Sum | 6479977 |
| Variance | 147281.3234 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 211 | 112 | 0.7% | |
| 228 | 108 | 0.6% | |
| 256 | 105 | 0.6% | |
| 391 | 97 | 0.6% | |
| 74 | 95 | 0.6% | |
| 387 | 94 | 0.6% | |
| 325 | 94 | 0.6% | |
| 493 | 91 | 0.5% | |
| 101 | 90 | 0.5% | |
| 207 | 90 | 0.5% | |
| Other values (459) | 16024 | 94.3% |
| Value | Count | Frequency (%) | |
| 5 | 5 | < 0.1% | |
| 6 | 5 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 8 | 4 | < 0.1% | |
| 9 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2682 | 67 | 0.4% | |
| 2288 | 76 | 0.4% | |
| 1936 | 52 | 0.3% | |
| 1831 | 85 | 0.5% | |
| 1485 | 83 | 0.5% |
| Distinct | 731 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| 8/2/2017 | 80 |
|---|---|
| 9/15/2016 | 76 |
| 4/5/2017 | 66 |
| 10/27/2015 | 56 |
| 3/29/2016 | 55 |
| Other values (726) |
| Value | Count | Frequency (%) | |
| 8/2/2017 | 80 | 0.5% | |
| 9/15/2016 | 76 | 0.4% | |
| 4/5/2017 | 66 | 0.4% | |
| 10/27/2015 | 56 | 0.3% | |
| 3/29/2016 | 55 | 0.3% | |
| 8/14/2016 | 55 | 0.3% | |
| 9/29/2015 | 55 | 0.3% | |
| 11/3/2015 | 54 | 0.3% | |
| 8/18/2015 | 53 | 0.3% | |
| 8/30/2016 | 51 | 0.3% | |
| Other values (721) | 16399 | 96.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.936764706 |
| Min length | 8 |
Average_Score
Real number (ℝ≥0)
| Distinct | 33 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.403347059 |
|---|---|
| Minimum | 6.4 |
| Maximum | 9.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 6.4 |
|---|---|
| 5-th percentile | 7.5 |
| Q1 | 8.1 |
| median | 8.4 |
| Q3 | 8.8 |
| 95-th percentile | 9.2 |
| Maximum | 9.8 |
| Range | 3.4 |
| Interquartile range (IQR) | 0.7 |
Descriptive statistics
| Standard deviation | 0.5322064392 |
|---|---|
| Coefficient of variation (CV) | 0.06333267393 |
| Kurtosis | 0.2225766328 |
| Mean | 8.403347059 |
| Median Absolute Deviation (MAD) | 0.3 |
| Skewness | -0.467020344 |
| Sum | 142856.9 |
| Variance | 0.2832436939 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 8.5 | 1484 | 8.7% | |
| 8.4 | 1358 | 8.0% | |
| 8.6 | 1318 | 7.8% | |
| 8.1 | 1220 | 7.2% | |
| 8.2 | 1219 | 7.2% | |
| 8.8 | 1036 | 6.1% | |
| 8.7 | 1018 | 6.0% | |
| 8.3 | 993 | 5.8% | |
| 8.9 | 932 | 5.5% | |
| 9 | 751 | 4.4% | |
| Other values (23) | 5671 | 33.4% |
| Value | Count | Frequency (%) | |
| 6.4 | 27 | 0.2% | |
| 6.6 | 12 | 0.1% | |
| 6.7 | 28 | 0.2% | |
| 6.8 | 38 | 0.2% | |
| 6.9 | 56 | 0.3% |
| Value | Count | Frequency (%) | |
| 9.8 | 3 | < 0.1% | |
| 9.6 | 30 | 0.2% | |
| 9.5 | 50 | 0.3% | |
| 9.4 | 231 | 1.4% | |
| 9.3 | 445 | 2.6% |
| Distinct | 1364 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| Park Grand Paddington Court | 88 |
|---|---|
| Copthorne Tara Hotel London Kensington | 85 |
| Hilton London Metropole | 83 |
| Strand Palace Hotel | 76 |
| The Cumberland A Guoman Hotel | 75 |
| Other values (1359) |
| Value | Count | Frequency (%) | |
| Park Grand Paddington Court | 88 | 0.5% | |
| Copthorne Tara Hotel London Kensington | 85 | 0.5% | |
| Hilton London Metropole | 83 | 0.5% | |
| Strand Palace Hotel | 76 | 0.4% | |
| The Cumberland A Guoman Hotel | 75 | 0.4% | |
| Blakemore Hyde Park | 73 | 0.4% | |
| Britannia International Hotel Canary Wharf | 67 | 0.4% | |
| Glam Milano | 66 | 0.4% | |
| Best Western Premier Hotel Couture | 66 | 0.4% | |
| Ramada Apollo Amsterdam Centre | 65 | 0.4% | |
| Other values (1354) | 16256 | 95.6% |
Unique
| Unique | 85 ? |
|---|---|
| Unique (%) | 0.5% |
Length
| Max length | 60 |
|---|---|
| Median length | 23 |
| Mean length | 24.61535294 |
| Min length | 2 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| Spain | 500 |
|---|---|
| Poland | 500 |
| Italy | 500 |
| Switzerland | 500 |
| Sweden | 500 |
| Other values (29) |
| Value | Count | Frequency (%) | |
| Spain | 500 | 2.9% | |
| Poland | 500 | 2.9% | |
| Italy | 500 | 2.9% | |
| Switzerland | 500 | 2.9% | |
| Sweden | 500 | 2.9% | |
| Belgium | 500 | 2.9% | |
| Qatar | 500 | 2.9% | |
| Netherlands | 500 | 2.9% | |
| Austria | 500 | 2.9% | |
| United Arab Emirates | 500 | 2.9% | |
| Other values (24) | 12000 | 70.6% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 26 |
|---|---|
| Median length | 9 |
| Mean length | 10.47058824 |
| Min length | 7 |
| Distinct | 11586 |
|---|---|
| Distinct (%) | 68.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| No Negative | |
|---|---|
| Nothing | 422 |
| Nothing | 122 |
| nothing | 77 |
| 43 | |
| Other values (11581) |
| Value | Count | Frequency (%) | |
| No Negative | 4270 | 25.1% | |
| Nothing | 422 | 2.5% | |
| Nothing | 122 | 0.7% | |
| nothing | 77 | 0.5% | |
| 43 | 0.3% | ||
| Small room | 23 | 0.1% | |
| None | 23 | 0.1% | |
| Breakfast | 21 | 0.1% | |
| Location | 19 | 0.1% | |
| none | 16 | 0.1% | |
| Other values (11576) | 11964 | 70.4% |
Unique
| Unique | 11398 ? |
|---|---|
| Unique (%) | 67.0% |
Length
| Max length | 1951 |
|---|---|
| Median length | 40 |
| Mean length | 92.18141176 |
| Min length | 1 |
| Distinct | 240 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.16629412 |
|---|---|
| Minimum | 0 |
| Maximum | 380 |
| Zeros | 4270 |
| Zeros (%) | 25.1% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 9 |
| Q3 | 23 |
| 95-th percentile | 68 |
| Maximum | 380 |
| Range | 380 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 29.14347291 |
|---|---|
| Coefficient of variation (CV) | 1.604260766 |
| Kurtosis | 29.68266722 |
| Mean | 18.16629412 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 4.304346386 |
| Sum | 308827 |
| Variance | 849.3420134 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 4270 | 25.1% | |
| 2 | 819 | 4.8% | |
| 6 | 601 | 3.5% | |
| 7 | 565 | 3.3% | |
| 3 | 547 | 3.2% | |
| 5 | 539 | 3.2% | |
| 4 | 509 | 3.0% | |
| 9 | 506 | 3.0% | |
| 8 | 490 | 2.9% | |
| 10 | 413 | 2.4% | |
| Other values (230) | 7741 | 45.5% |
| Value | Count | Frequency (%) | |
| 0 | 4270 | 25.1% | |
| 2 | 819 | 4.8% | |
| 3 | 547 | 3.2% | |
| 4 | 509 | 3.0% | |
| 5 | 539 | 3.2% |
| Value | Count | Frequency (%) | |
| 380 | 1 | < 0.1% | |
| 376 | 1 | < 0.1% | |
| 375 | 2 | < 0.1% | |
| 365 | 1 | < 0.1% | |
| 361 | 1 | < 0.1% |
Total_Number_of_Reviews
Real number (ℝ≥0)
| Distinct | 1061 |
|---|---|
| Distinct (%) | 6.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2418.115235 |
|---|---|
| Minimum | 59 |
| Maximum | 9568 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 59 |
|---|---|
| 5-th percentile | 392 |
| Q1 | 1057 |
| median | 1901 |
| Q3 | 3342 |
| 95-th percentile | 6512.4 |
| Maximum | 9568 |
| Range | 9509 |
| Interquartile range (IQR) | 2285 |
Descriptive statistics
| Standard deviation | 1814.168768 |
|---|---|
| Coefficient of variation (CV) | 0.7502408247 |
| Kurtosis | 1.656460075 |
| Mean | 2418.115235 |
| Median Absolute Deviation (MAD) | 1006 |
| Skewness | 1.298354301 |
| Sum | 41107959 |
| Variance | 3291208.32 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 6608 | 88 | 0.5% | |
| 7105 | 85 | 0.5% | |
| 6977 | 83 | 0.5% | |
| 9568 | 76 | 0.4% | |
| 5180 | 75 | 0.4% | |
| 6596 | 73 | 0.4% | |
| 9086 | 67 | 0.4% | |
| 7371 | 66 | 0.4% | |
| 8177 | 66 | 0.4% | |
| 5770 | 65 | 0.4% | |
| Other values (1051) | 16256 | 95.6% |
| Value | Count | Frequency (%) | |
| 59 | 4 | < 0.1% | |
| 67 | 6 | < 0.1% | |
| 69 | 1 | < 0.1% | |
| 70 | 3 | < 0.1% | |
| 76 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 9568 | 76 | 0.4% | |
| 9086 | 67 | 0.4% | |
| 8177 | 66 | 0.4% | |
| 7586 | 57 | 0.3% | |
| 7491 | 52 | 0.3% |
| Distinct | 14193 |
|---|---|
| Distinct (%) | 83.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| No Positive | 1350 |
|---|---|
| Location | 378 |
| location | 77 |
| Everything | 73 |
| The location | 56 |
| Other values (14188) |
| Value | Count | Frequency (%) | |
| No Positive | 1350 | 7.9% | |
| Location | 378 | 2.2% | |
| location | 77 | 0.5% | |
| Everything | 73 | 0.4% | |
| The location | 56 | 0.3% | |
| Nothing | 46 | 0.3% | |
| Good location | 39 | 0.2% | |
| Great location | 35 | 0.2% | |
| Location | 30 | 0.2% | |
| Breakfast | 24 | 0.1% | |
| Other values (14183) | 14892 | 87.6% |
Unique
| Unique | 13891 ? |
|---|---|
| Unique (%) | 81.7% |
Length
| Max length | 1955 |
|---|---|
| Median length | 54 |
| Mean length | 90.05617647 |
| Min length | 1 |
| Distinct | 186 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.88029412 |
|---|---|
| Minimum | 0 |
| Maximum | 373 |
| Zeros | 1350 |
| Zeros (%) | 7.9% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 5 |
| median | 10 |
| Q3 | 21 |
| 95-th percentile | 54 |
| Maximum | 373 |
| Range | 373 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 21.23786636 |
|---|---|
| Coefficient of variation (CV) | 1.258145516 |
| Kurtosis | 30.02590695 |
| Mean | 16.88029412 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.072515925 |
| Sum | 286965 |
| Variance | 451.0469674 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 1350 | 7.9% | |
| 5 | 982 | 5.8% | |
| 6 | 929 | 5.5% | |
| 3 | 865 | 5.1% | |
| 4 | 838 | 4.9% | |
| 2 | 834 | 4.9% | |
| 7 | 805 | 4.7% | |
| 9 | 683 | 4.0% | |
| 8 | 663 | 3.9% | |
| 10 | 619 | 3.6% | |
| Other values (176) | 8432 | 49.6% |
| Value | Count | Frequency (%) | |
| 0 | 1350 | 7.9% | |
| 2 | 834 | 4.9% | |
| 3 | 865 | 5.1% | |
| 4 | 838 | 4.9% | |
| 5 | 982 | 5.8% |
| Value | Count | Frequency (%) | |
| 373 | 1 | < 0.1% | |
| 308 | 1 | < 0.1% | |
| 291 | 1 | < 0.1% | |
| 289 | 1 | < 0.1% | |
| 281 | 1 | < 0.1% |
Total_Number_of_Reviews_Reviewer_Has_Given
Real number (ℝ≥0)
| Distinct | 126 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.639470588 |
|---|---|
| Minimum | 1 |
| Maximum | 315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 5 |
| Q3 | 12 |
| 95-th percentile | 33 |
| Maximum | 315 |
| Range | 314 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 13.76445716 |
|---|---|
| Coefficient of variation (CV) | 1.427926672 |
| Kurtosis | 39.78164827 |
| Mean | 9.639470588 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 4.538576177 |
| Sum | 163871 |
| Variance | 189.4602809 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 3674 | 21.6% | |
| 2 | 1768 | 10.4% | |
| 3 | 1424 | 8.4% | |
| 4 | 1147 | 6.7% | |
| 5 | 931 | 5.5% | |
| 6 | 825 | 4.9% | |
| 7 | 714 | 4.2% | |
| 8 | 638 | 3.8% | |
| 9 | 543 | 3.2% | |
| 10 | 498 | 2.9% | |
| Other values (116) | 4838 | 28.5% |
| Value | Count | Frequency (%) | |
| 1 | 3674 | 21.6% | |
| 2 | 1768 | 10.4% | |
| 3 | 1424 | 8.4% | |
| 4 | 1147 | 6.7% | |
| 5 | 931 | 5.5% |
| Value | Count | Frequency (%) | |
| 315 | 1 | < 0.1% | |
| 199 | 1 | < 0.1% | |
| 191 | 1 | < 0.1% | |
| 173 | 1 | < 0.1% | |
| 171 | 1 | < 0.1% |
Reviewer_Score
Real number (ℝ≥0)
| Distinct | 35 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.234694118 |
|---|---|
| Minimum | 2.5 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 2.5 |
|---|---|
| 5-th percentile | 4.6 |
| Q1 | 7.5 |
| median | 8.8 |
| Q3 | 9.6 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 7.5 |
| Interquartile range (IQR) | 2.1 |
Descriptive statistics
| Standard deviation | 1.677791833 |
|---|---|
| Coefficient of variation (CV) | 0.2037467098 |
| Kurtosis | 0.6766519468 |
| Mean | 8.234694118 |
| Median Absolute Deviation (MAD) | 0.9 |
| Skewness | -1.088897042 |
| Sum | 139989.8 |
| Variance | 2.814985435 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 10 | 3135 | 18.4% | |
| 9.6 | 2146 | 12.6% | |
| 9.2 | 1930 | 11.4% | |
| 8.8 | 1657 | 9.7% | |
| 8.3 | 1504 | 8.8% | |
| 7.5 | 1195 | 7.0% | |
| 7.9 | 1185 | 7.0% | |
| 7.1 | 865 | 5.1% | |
| 6.7 | 681 | 4.0% | |
| 6.3 | 577 | 3.4% | |
| Other values (25) | 2125 | 12.5% |
| Value | Count | Frequency (%) | |
| 2.5 | 77 | 0.5% | |
| 2.9 | 68 | 0.4% | |
| 3 | 2 | < 0.1% | |
| 3.3 | 112 | 0.7% | |
| 3.5 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 10 | 3135 | 18.4% | |
| 9.6 | 2146 | 12.6% | |
| 9.5 | 32 | 0.2% | |
| 9.2 | 1930 | 11.4% | |
| 9 | 26 | 0.2% |
| Distinct | 7413 |
|---|---|
| Distinct (%) | 43.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| [' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 68 |
|---|---|
| [' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 66 |
| [' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights '] | 64 |
| [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights '] | 63 |
| [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device '] | 59 |
| Other values (7408) |
| Value | Count | Frequency (%) | |
| [' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 68 | 0.4% | |
| [' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 66 | 0.4% | |
| [' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 2 nights '] | 64 | 0.4% | |
| [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights '] | 63 | 0.4% | |
| [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device '] | 59 | 0.3% | |
| [' Leisure trip ', ' Couple ', ' Standard Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device '] | 57 | 0.3% | |
| [' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 56 | 0.3% | |
| [' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights '] | 55 | 0.3% | |
| [' Leisure trip ', ' Couple ', ' Double Room ', ' Stayed 1 night '] | 55 | 0.3% | |
| [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 55 | 0.3% | |
| Other values (7403) | 16402 | 96.5% |
Unique
| Unique | 5253 ? |
|---|---|
| Unique (%) | 30.9% |
Length
| Max length | 213 |
|---|---|
| Median length | 105 |
| Mean length | 101.7076471 |
| Min length | 30 |
| Distinct | 731 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| 1 days | 80 |
|---|---|
| 322 day | 76 |
| 120 day | 66 |
| 646 day | 56 |
| 674 day | 55 |
| Other values (726) |
| Value | Count | Frequency (%) | |
| 1 days | 80 | 0.5% | |
| 322 day | 76 | 0.4% | |
| 120 day | 66 | 0.4% | |
| 646 day | 56 | 0.3% | |
| 674 day | 55 | 0.3% | |
| 354 day | 55 | 0.3% | |
| 492 day | 55 | 0.3% | |
| 639 day | 54 | 0.3% | |
| 716 day | 53 | 0.3% | |
| 578 day | 51 | 0.3% | |
| Other values (721) | 16399 | 96.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 6.983823529 |
| Min length | 6 |
lat
Real number (ℝ≥0)
| Distinct | 1349 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 147 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 48.70350193 |
|---|---|
| Minimum | 41.3283758 |
| Maximum | 52.4001813 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 41.3283758 |
|---|---|
| 5-th percentile | 41.384829 |
| Q1 | 48.1756283 |
| median | 48.8793427 |
| Q3 | 51.5144004 |
| 95-th percentile | 52.3702469 |
| Maximum | 52.4001813 |
| Range | 11.0718055 |
| Interquartile range (IQR) | 3.3387721 |
Descriptive statistics
| Standard deviation | 3.688259769 |
|---|---|
| Coefficient of variation (CV) | 0.07572884131 |
| Kurtosis | -0.3447617847 |
| Mean | 48.70350193 |
| Median Absolute Deviation (MAD) | 2.6346902 |
| Skewness | -0.9779669749 |
| Sum | 820800.118 |
| Variance | 13.60326012 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 51.5135555 | 88 | 0.5% | |
| 51.499046 | 85 | 0.5% | |
| 51.5195688 | 83 | 0.5% | |
| 51.5110993 | 76 | 0.4% | |
| 51.514879 | 75 | 0.4% | |
| 51.5129736 | 73 | 0.4% | |
| 51.5019097 | 67 | 0.4% | |
| 52.3511137 | 66 | 0.4% | |
| 45.4838504 | 66 | 0.4% | |
| 52.3681299 | 65 | 0.4% | |
| Other values (1339) | 16109 | 94.8% | |
| (Missing) | 147 | 0.9% |
| Value | Count | Frequency (%) | |
| 41.3283758 | 25 | 0.1% | |
| 41.368437 | 26 | 0.2% | |
| 41.3703041 | 8 | < 0.1% | |
| 41.371308 | 53 | 0.3% | |
| 41.3725246 | 6 | < 0.1% |
| Value | Count | Frequency (%) | |
| 52.4001813 | 11 | 0.1% | |
| 52.3924898 | 10 | 0.1% | |
| 52.3923684 | 3 | < 0.1% | |
| 52.3872884 | 25 | 0.1% | |
| 52.3856494 | 54 | 0.3% |
lng
Real number (ℝ)
| Distinct | 1349 |
|---|---|
| Distinct (%) | 8.0% |
| Missing | 147 |
| Missing (%) | 0.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.965988724 |
|---|---|
| Minimum | -0.3192925 |
| Maximum | 16.4217627 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | -0.3192925 |
|---|---|
| 5-th percentile | -0.1882164 |
| Q1 | -0.1283489 |
| median | 2.211756 |
| Q3 | 4.8943658 |
| 95-th percentile | 16.3710205 |
| Maximum | 16.4217627 |
| Range | 16.7410552 |
| Interquartile range (IQR) | 5.0227147 |
Descriptive statistics
| Standard deviation | 5.207436922 |
|---|---|
| Coefficient of variation (CV) | 1.313023633 |
| Kurtosis | 0.9047414419 |
| Mean | 3.965988724 |
| Median Absolute Deviation (MAD) | 2.3683066 |
| Skewness | 1.44714942 |
| Sum | 66838.80797 |
| Variance | 27.1173993 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| -0.180002 | 88 | 0.5% | |
| -0.1917073 | 85 | 0.5% | |
| -0.170521 | 83 | 0.5% | |
| -0.1208673 | 76 | 0.4% | |
| -0.1606501 | 75 | 0.4% | |
| -0.1837431 | 73 | 0.4% | |
| -0.0232208 | 67 | 0.4% | |
| 4.8411629 | 66 | 0.4% | |
| 9.2034067 | 66 | 0.4% | |
| -0.1565506 | 65 | 0.4% | |
| Other values (1339) | 16109 | 94.8% | |
| (Missing) | 147 | 0.9% |
| Value | Count | Frequency (%) | |
| -0.3192925 | 6 | < 0.1% | |
| -0.306071 | 1 | < 0.1% | |
| -0.2915052 | 5 | < 0.1% | |
| -0.290706 | 11 | 0.1% | |
| -0.2864945 | 21 | 0.1% |
| Value | Count | Frequency (%) | |
| 16.4217627 | 27 | 0.2% | |
| 16.4200957 | 31 | 0.2% | |
| 16.4133973 | 11 | 0.1% | |
| 16.4129493 | 32 | 0.2% | |
| 16.4116997 | 9 | 0.1% |
| Distinct | 16727 |
|---|---|
| Distinct (%) | 98.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| Location. No Negative | 41 |
|---|---|
| Everything. Nothing | 35 |
| Everything. No Negative | 16 |
| Everything . No Negative | 11 |
| location. No Negative | 11 |
| Other values (16722) |
| Value | Count | Frequency (%) | |
| Location. No Negative | 41 | 0.2% | |
| Everything. Nothing | 35 | 0.2% | |
| Everything. No Negative | 16 | 0.1% | |
| Everything . No Negative | 11 | 0.1% | |
| location. No Negative | 11 | 0.1% | |
| Location. Nothing | 10 | 0.1% | |
| Great location. No Negative | 8 | < 0.1% | |
| No Positive. No Negative | 7 | < 0.1% | |
| Everything was perfect . No Negative | 6 | < 0.1% | |
| Great location . No Negative | 6 | < 0.1% | |
| Other values (16717) | 16849 | 99.1% |
Unique
| Unique | 16639 ? |
|---|---|
| Unique (%) | 97.9% |
Length
| Max length | 3231 |
|---|---|
| Median length | 123 |
| Mean length | 184.2375882 |
| Min length | 4 |
| Distinct | 18 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1335000052 |
|---|---|
| Minimum | -0.8000000119 |
| Maximum | 0.8999999762 |
| Zeros | 3948 |
| Zeros (%) | 23.2% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | -0.8000000119 |
|---|---|
| 5-th percentile | -0.6999999881 |
| Q1 | 0 |
| median | 0.1000000015 |
| Q3 | 0.5 |
| 95-th percentile | 0.6000000238 |
| Maximum | 0.8999999762 |
| Range | 1.699999988 |
| Interquartile range (IQR) | 0.5 |
Descriptive statistics
| Standard deviation | 0.3807389717 |
|---|---|
| Coefficient of variation (CV) | 2.851977206 |
| Kurtosis | -0.1105772972 |
| Mean | 0.1335000052 |
| Median Absolute Deviation (MAD) | 0.2000000104 |
| Skewness | -0.4567576258 |
| Sum | 2269.500088 |
| Variance | 0.1449621646 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0 | 3948 | 23.2% | |
| 0.6000000238 | 3411 | 20.1% | |
| 0.1000000015 | 2065 | 12.1% | |
| 0.200000003 | 1405 | 8.3% | |
| 0.3000000119 | 869 | 5.1% | |
| -0.6999999881 | 733 | 4.3% | |
| -0.1000000015 | 726 | 4.3% | |
| 0.5 | 686 | 4.0% | |
| 0.400000006 | 635 | 3.7% | |
| -0.200000003 | 604 | 3.6% | |
| Other values (8) | 1918 | 11.3% |
| Value | Count | Frequency (%) | |
| -0.8000000119 | 314 | 1.8% | |
| -0.6999999881 | 733 | 4.3% | |
| -0.6000000238 | 282 | 1.7% | |
| -0.5 | 223 | 1.3% | |
| -0.400000006 | 272 | 1.6% |
| Value | Count | Frequency (%) | |
| 0.8999999762 | 170 | 1.0% | |
| 0.8000000119 | 130 | 0.8% | |
| 0.6999999881 | 126 | 0.7% | |
| 0.6000000238 | 3411 | 20.1% | |
| 0.5 | 686 | 4.0% |
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5839235197 |
|---|---|
| Minimum | -0.8999999762 |
| Maximum | 0.8999999762 |
| Zeros | 456 |
| Zeros (%) | 2.7% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | -0.8999999762 |
|---|---|
| 5-th percentile | -0.6999999881 |
| Q1 | 0.400000006 |
| median | 0.8999999762 |
| Q3 | 0.8999999762 |
| 95-th percentile | 0.8999999762 |
| Maximum | 0.8999999762 |
| Range | 1.799999952 |
| Interquartile range (IQR) | 0.4999999702 |
Descriptive statistics
| Standard deviation | 0.5021722407 |
|---|---|
| Coefficient of variation (CV) | 0.8599965986 |
| Kurtosis | 1.357222316 |
| Mean | 0.5839235197 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -1.618109622 |
| Sum | 9926.699834 |
| Variance | 0.2521769594 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0.8999999762 | 8973 | 52.8% | |
| 0.8000000119 | 1858 | 10.9% | |
| -0.6999999881 | 1417 | 8.3% | |
| 0.400000006 | 850 | 5.0% | |
| 0.6999999881 | 755 | 4.4% | |
| 0.200000003 | 516 | 3.0% | |
| 0 | 456 | 2.7% | |
| 0.6000000238 | 439 | 2.6% | |
| 0.3000000119 | 411 | 2.4% | |
| 0.5 | 380 | 2.2% | |
| Other values (9) | 945 | 5.6% |
| Value | Count | Frequency (%) | |
| -0.8999999762 | 4 | < 0.1% | |
| -0.8000000119 | 64 | 0.4% | |
| -0.6999999881 | 1417 | 8.3% | |
| -0.6000000238 | 60 | 0.4% | |
| -0.5 | 60 | 0.4% |
| Value | Count | Frequency (%) | |
| 0.8999999762 | 8973 | 52.8% | |
| 0.8000000119 | 1858 | 10.9% | |
| 0.6999999881 | 755 | 4.4% | |
| 0.6000000238 | 439 | 2.6% | |
| 0.5 | 380 | 2.2% |
| Distinct | 19 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.2768941173 |
|---|---|
| Minimum | -0.8999999762 |
| Maximum | 0.8999999762 |
| Zeros | 705 |
| Zeros (%) | 4.1% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | -0.8999999762 |
|---|---|
| 5-th percentile | -0.8000000119 |
| Q1 | -0.6999999881 |
| median | -0.400000006 |
| Q3 | 0.3000000119 |
| 95-th percentile | 0.3000000119 |
| Maximum | 0.8999999762 |
| Range | 1.799999952 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.4705307075 |
|---|---|
| Coefficient of variation (CV) | -1.699316374 |
| Kurtosis | -1.245651457 |
| Mean | -0.2768941173 |
| Median Absolute Deviation (MAD) | 0.400000006 |
| Skewness | 0.4383320891 |
| Sum | -4707.199995 |
| Variance | 0.2213991467 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 0.3000000119 | 4467 | 26.3% | |
| -0.6999999881 | 3015 | 17.7% | |
| -0.8000000119 | 2818 | 16.6% | |
| -0.6000000238 | 1543 | 9.1% | |
| -0.400000006 | 1175 | 6.9% | |
| -0.5 | 838 | 4.9% | |
| 0 | 705 | 4.1% | |
| -0.3000000119 | 487 | 2.9% | |
| -0.200000003 | 446 | 2.6% | |
| -0.1000000015 | 372 | 2.2% | |
| Other values (9) | 1134 | 6.7% |
| Value | Count | Frequency (%) | |
| -0.8999999762 | 74 | 0.4% | |
| -0.8000000119 | 2818 | 16.6% | |
| -0.6999999881 | 3015 | 17.7% | |
| -0.6000000238 | 1543 | 9.1% | |
| -0.5 | 838 | 4.9% |
| Value | Count | Frequency (%) | |
| 0.8999999762 | 168 | 1.0% | |
| 0.8000000119 | 95 | 0.6% | |
| 0.6999999881 | 74 | 0.4% | |
| 0.6000000238 | 62 | 0.4% | |
| 0.5 | 75 | 0.4% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 556 |
| Missing (%) | 3.3% |
| Memory size | 132.8 KiB |
| leisure | |
|---|---|
| business |
| Value | Count | Frequency (%) | |
| leisure | 12842 | 75.5% | |
| business | 3602 | 21.2% | |
| (Missing) | 556 | 3.3% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.081058824 |
| Min length | 3 |
From_Mobile
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| 1 | |
|---|---|
| 0 |
| Value | Count | Frequency (%) | |
| 1 | 9146 | 53.8% | |
| 0 | 7854 | 46.2% |
N_Persons
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.8 KiB |
| couple | |
|---|---|
| solo | |
| family | |
| group |
| Value | Count | Frequency (%) | |
| couple | 6841 | 40.2% | |
| solo | 4549 | 26.8% | |
| family | 3485 | 20.5% | |
| group | 2125 | 12.5% |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.339823529 |
| Min length | 4 |
Stayed_Nights
Real number (ℝ≥0)
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 6 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.823761328 |
|---|---|
| Minimum | 1 |
| Maximum | 28 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 132.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 28 |
| Range | 27 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.884769165 |
|---|---|
| Coefficient of variation (CV) | 0.6674675888 |
| Kurtosis | 11.65129454 |
| Mean | 2.823761328 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.247220293 |
| Sum | 47987 |
| Variance | 3.552354804 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) | |
| 1 | 4398 | 25.9% | |
| 2 | 4336 | 25.5% | |
| 3 | 3724 | 21.9% | |
| 4 | 2165 | 12.7% | |
| 5 | 1045 | 6.1% | |
| 6 | 543 | 3.2% | |
| 7 | 394 | 2.3% | |
| 8 | 156 | 0.9% | |
| 9 | 86 | 0.5% | |
| 10 | 51 | 0.3% | |
| Other values (12) | 96 | 0.6% |
| Value | Count | Frequency (%) | |
| 1 | 4398 | 25.9% | |
| 2 | 4336 | 25.5% | |
| 3 | 3724 | 21.9% | |
| 4 | 2165 | 12.7% | |
| 5 | 1045 | 6.1% |
| Value | Count | Frequency (%) | |
| 28 | 1 | < 0.1% | |
| 27 | 2 | < 0.1% | |
| 22 | 1 | < 0.1% | |
| 19 | 2 | < 0.1% | |
| 18 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| Hotel_Address | Additional_Number_of_Scoring | Review_Date | Average_Score | Hotel_Name | Reviewer_Nationality | Negative_Review | Review_Total_Negative_Word_Counts | Total_Number_of_Reviews | Positive_Review | Review_Total_Positive_Word_Counts | Total_Number_of_Reviews_Reviewer_Has_Given | Reviewer_Score | Tags | days_since_review | lat | lng | Review | Review_sent | Positive_Review_sent | Negative_Review_sent | Travel_type | From_Mobile | N_Persons | Stayed_Nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 8 Avenue Rapp 7th arr 75007 Paris France | 74 | 7/5/2016 | 8.9 | Derby Alma | United Kingdom | Parking But it s all the same in any city I suppose expensive and rare to find a space Lol | 21 | 509 | Cracking view of the tower | 7.0 | 3.0 | 8.3 | [' Leisure trip ', ' Family with young children ', ' Family Suite ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 394 day | 48.860503 | 2.300661 | Cracking view of the tower . Parking But it s all the same in any city I suppose expensive and rare to find a space Lol | 0.2 | 0.8 | -0.2 | leisure | 1.0 | family | 1.0 |
| 1 | Lakeside Way Brent London HA9 0BU United Kingdom | 1427 | 12/14/2016 | 8.8 | Hilton London Wembley | United Kingdom | The second night with X factor personnel staying at the hotel I was denied entry to the hotel as I was wearing jeans and a t shirt and a Santa hat as I had been a guest at the royal Albert hall On my return to the hotel the entrance was cordoned off due to somebody called Sharon Osborn being in the hotel lobby I had to wait over 20 minutes for security to eventually say if you are actually a guest you should have a key card I showed him my key card and eventually he let me in Then once entering the hotel was stopped again by X factor staff wanting to know why I was coming into the hotel I had to show my key card again to prove I was a guest My second evening was ruined by staff at the Hilton Wembley and security staff | 152 | 4305 | First night was fine second night was a nightmare as some staff and judges from the X factor were staying in the hotel | 25.0 | 1.0 | 7.9 | [' Leisure trip ', ' Group ', ' Deluxe King Room with Stadium View ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 232 day | 51.557696 | -0.283526 | First night was fine second night was a nightmare as some staff and judges from the X factor were staying in the hotel . The second night with X factor personnel staying at the hotel I was denied entry to the hotel as I was wearing jeans and a t shirt and a Santa hat as I had been a guest at the royal Albert hall On my return to the hotel the entrance was cordoned off due to somebody called Sharon Osborn being in the hotel lobby I had to wait over 20 minutes for security to eventually say if you are actually a guest you should have a key card I showed him my key card and eventually he let me in Then once entering the hotel was stopped again by X factor staff wanting to know why I was coming into the hotel I had to show my key card again to prove I was a guest My second evening was ruined by staff at the Hilton Wembley and security staff | -0.7 | -0.7 | -0.7 | leisure | 1.0 | group | 2.0 |
| 2 | 225 Edgware Road Westminster Borough London W2 1JU United Kingdom | 1485 | 8/30/2016 | 7.5 | Hilton London Metropole | United Kingdom | Rude staff room not ready at 3 30 pm Request early check in and late check out not accept | 21 | 6977 | No Positive | 0.0 | 2.0 | 4.6 | [' Leisure trip ', ' Family with young children ', ' King Hilton Guest Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 338 day | 51.519569 | -0.170521 | No Positive. Rude staff room not ready at 3 30 pm Request early check in and late check out not accept | -0.7 | -0.7 | -0.7 | leisure | 1.0 | family | 1.0 |
| 3 | 1 3 Queens Garden Westminster Borough London W2 3BA United Kingdom | 1058 | 5/28/2017 | 7.7 | The Park Grand London Paddington | United Kingdom | No Negative | 0 | 4380 | The hotel was perfect for a short stay in the heart of London very conveniently located for Paddington station and the Heathrow Express Highly recommended | 27.0 | 2.0 | 8.8 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night '] | 67 days | 51.514218 | -0.180903 | The hotel was perfect for a short stay in the heart of London very conveniently located for Paddington station and the Heathrow Express Highly recommended . No Negative | 0.6 | 0.9 | 0.3 | leisure | 0.0 | couple | 1.0 |
| 4 | Via Mauro Macchi 1 Central Station 20124 Milan Italy | 65 | 11/2/2015 | 8.4 | Hotel Mediolanum | United Kingdom | Unfriendly staff | 3 | 885 | The furniture | 3.0 | 17.0 | 5.8 | [' Leisure trip ', ' Group ', ' Double or Twin Room ', ' Stayed 3 nights ', ' Submitted from a mobile device '] | 640 day | 45.481342 | 9.203949 | The furniture. Unfriendly staff | -0.3 | 0.1 | -0.8 | leisure | 1.0 | group | 3.0 |
| 5 | 26 28 Trebovir Rd Kensington and Chelsea London SW5 9NJ United Kingdom | 328 | 9/9/2016 | 7.5 | Mayflower Hotel Apartments | United Kingdom | The quilt bedding had two stains on when i went to reception the did give me another cover leaving me to change the bedding The rooms didn t have air conditioning which we knew about when booking The fan left in our room was no use and the room was like a sauna which wouldn t of been so bad if our window wasn t level with the garden seating so everyone could see in meaning we couldn t really leave the curtains and windows open to deal with the heat issue The floor in the room was incredibly creaky so it made it impossible to get up in the night to go to the bathroom without waking your partner up The hallway flooring was also very creaky also so you could hear people walking past our room to get to theirs | 144 | 2197 | Location is brilliant near tube station and cheap for london free wifi The place overall presented very clean and smart | 22.0 | 2.0 | 6.3 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room with Four Poster Bed ', ' Stayed 3 nights '] | 328 day | 51.491668 | -0.194747 | Location is brilliant near tube station and cheap for london free wifi The place overall presented very clean and smart . The quilt bedding had two stains on when i went to reception the did give me another cover leaving me to change the bedding The rooms didn t have air conditioning which we knew about when booking The fan left in our room was no use and the room was like a sauna which wouldn t of been so bad if our window wasn t level with the garden seating so everyone could see in meaning we couldn t really leave the curtains and windows open to deal with the heat issue The floor in the room was incredibly creaky so it made it impossible to get up in the night to go to the bathroom without waking your partner up The hallway flooring was also very creaky also so you could hear people walking past our room to get to theirs | 0.0 | 0.9 | -0.8 | leisure | 0.0 | couple | 3.0 |
| 6 | 52 56 Inverness Terrace Westminster Borough London W2 3LB United Kingdom | 545 | 7/2/2017 | 8.0 | Shaftesbury Hyde Park International | United Kingdom | The luxury room we stayed in the cost 176 per night without breakfast was no bigger than 7ft square it was absolutely ridiculous We had continuous buzzing noise all night and the towel rail was hanging off It was a total rip off | 45 | 2907 | Decorating was the only nice part of the room | 10.0 | 2.0 | 3.3 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 32 days | 51.512397 | -0.186124 | Decorating was the only nice part of the room. The luxury room we stayed in the cost 176 per night without breakfast was no bigger than 7ft square it was absolutely ridiculous We had continuous buzzing noise all night and the towel rail was hanging off It was a total rip off | -0.6 | -0.4 | -0.7 | leisure | 1.0 | couple | 1.0 |
| 7 | John M Keynesplein 2 Slotervaart 1066 EP Amsterdam Netherlands | 350 | 12/2/2016 | 7.9 | Dutch Design Hotel Artemis | United Kingdom | should have been a bit more cleaner | 8 | 2167 | Nice friendly staff | 4.0 | 3.0 | 7.5 | [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 244 day | 52.341789 | 4.824952 | Nice friendly staff. should have been a bit more cleaner | 0.1 | 0.9 | -0.7 | leisure | 1.0 | couple | 2.0 |
| 8 | 15 Beeston Place Westminster Borough London SW1W 0JW United Kingdom | 67 | 7/7/2017 | 9.4 | The Goring | United Kingdom | No seperate shower cubicle | 5 | 200 | Conceirge doorman lovely bar | 5.0 | 1.0 | 8.8 | [' Leisure trip ', ' Couple ', ' Delightful Queen Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 27 days | 51.497562 | -0.145551 | Conceirge doorman lovely bar. No seperate shower cubicle | 0.1 | 0.9 | -0.6 | leisure | 1.0 | couple | 1.0 |
| 9 | Excel 2 Festoon Way Royal Victoria Dock Newham London E16 1RH United Kingdom | 853 | 9/15/2016 | 8.4 | DoubleTree By Hilton London Excel | United Kingdom | No Negative | 0 | 2726 | Very good and clean | 5.0 | 1.0 | 7.9 | [' Leisure trip ', ' Couple ', ' Deluxe Queen Room with View ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 322 day | 51.507377 | 0.038657 | Very good and clean. No Negative | 0.6 | 0.9 | 0.3 | leisure | 1.0 | couple | 2.0 |
Last rows
| Hotel_Address | Additional_Number_of_Scoring | Review_Date | Average_Score | Hotel_Name | Reviewer_Nationality | Negative_Review | Review_Total_Negative_Word_Counts | Total_Number_of_Reviews | Positive_Review | Review_Total_Positive_Word_Counts | Total_Number_of_Reviews_Reviewer_Has_Given | Reviewer_Score | Tags | days_since_review | lat | lng | Review | Review_sent | Positive_Review_sent | Negative_Review_sent | Travel_type | From_Mobile | N_Persons | Stayed_Nights | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16990 | Provincialeweg 38 Zuidoost 1108 AB Amsterdam Netherlands | 245 | 1/28/2017 | 7.5 | Golden Tulip Amsterdam Riverside | Czech Republic | No Negative | 0 | 2362 | Excellent service and receptive staff | 6.0 | 2.0 | 10.0 | [' Leisure trip ', ' Couple ', ' Standard Twin Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 187 day | 52.315453 | 4.996300 | Excellent service and receptive staff. No Negative | 0.6 | 0.9 | 0.3 | leisure | 1.0 | couple | 1.0 |
| 16991 | Tiefer Graben 14 20 01 Innere Stadt 1010 Vienna Austria | 153 | 2/16/2016 | 8.9 | Hotel Das Tigra | Czech Republic | No Negative | 0 | 1817 | the stuff was nice and helfull | 7.0 | 5.0 | 10.0 | [' Leisure trip ', ' Family with young children ', ' Comfort Double Room ', ' Stayed 1 night '] | 534 day | 48.212177 | 16.368077 | the stuff was nice and helfull. No Negative | 0.5 | 0.8 | 0.3 | leisure | 0.0 | family | 1.0 |
| 16992 | Rec Comtal 16 18 Ciutat Vella 08003 Barcelona Spain | 211 | 2/24/2017 | 8.8 | Catalonia Born | Czech Republic | Pillows | 2 | 2094 | Breakfast Location | 3.0 | 14.0 | 9.6 | [' Business trip ', ' Couple ', ' Double Room ', ' Stayed 2 nights '] | 160 day | 41.389692 | 2.179866 | Breakfast Location. Pillows | 0.1 | 0.2 | 0.0 | business | 0.0 | couple | 2.0 |
| 16993 | Via Lentasio 3 Milan City Center 20122 Milan Italy | 172 | 5/28/2017 | 7.7 | Best Western Hotel Ascot | Czech Republic | No Negative | 0 | 1741 | Very friendly and helpful personal | 6.0 | 18.0 | 9.2 | [' Business trip ', ' Solo traveler ', ' Standard Single Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 67 days | 45.458014 | 9.191368 | Very friendly and helpful personal. No Negative | 0.6 | 0.9 | 0.3 | business | 1.0 | solo | 2.0 |
| 16994 | 59 Leinster Square Kensington and Chelsea London W2 4PS United Kingdom | 337 | 6/10/2017 | 7.6 | New Linden Hotel | Czech Republic | Extremely small room Continental breakfast Uncomfortable bed | 9 | 2820 | Quiet street in a good lovation | 7.0 | 15.0 | 4.6 | [' Business trip ', ' Solo traveler ', ' Standard Double Room ', ' Stayed 2 nights ', ' Submitted from a mobile device '] | 54 days | 51.513383 | -0.192662 | Quiet street in a good lovation. Extremely small room Continental breakfast Uncomfortable bed | 0.1 | 0.9 | -0.6 | business | 1.0 | solo | 2.0 |
| 16995 | Delflandlaan 15 Slotervaart 1062 EA Amsterdam Netherlands | 947 | 8/31/2015 | 8.7 | Best Western Premier Hotel Couture | Czech Republic | Minibar not working Parking lot is not free | 9 | 8177 | Overall cleanness Good location New furnishings Nespresso in the room | 11.0 | 2.0 | 9.6 | [' Leisure trip ', ' Couple ', ' Standard Double or Twin Room ', ' Stayed 4 nights '] | 703 day | 52.351114 | 4.841163 | Overall cleanness Good location New furnishings Nespresso in the room. Minibar not working Parking lot is not free | 0.0 | 0.7 | -0.7 | leisure | 0.0 | couple | 4.0 |
| 16996 | Rooseveltplatz 15 09 Alsergrund 1090 Vienna Austria | 165 | 5/3/2016 | 8.4 | Hotel Regina | Czech Republic | single room is really small and I do not believe it is 4 limited breakfast | 16 | 1948 | perfect location | 3.0 | 12.0 | 6.7 | [' Business trip ', ' Solo traveler ', ' Single Room ', ' Stayed 2 nights '] | 457 day | 48.216334 | 16.359554 | perfect location. single room is really small and I do not believe it is 4 limited breakfast | 0.1 | 0.9 | -0.7 | business | 0.0 | solo | 2.0 |
| 16997 | 152 Cricklewood Broadway Cricklewood London NW2 3ED United Kingdom | 512 | 11/30/2015 | 8.0 | Clayton Crown Hotel London | Czech Republic | it was little bit cold inside of our room and the only temperature regulation device was from A C which did not realy heat Wifi signal was very weak in our room We had to go to the lobby to be well conneceted from neighboring rooms you here more than you wish Noise isolation is weak | 58 | 2491 | we were very happy with kind hotel stuff very good connection to public transportation hotel is nice clean and stylish even you need to pay extra for breakfast it is worth money it costs Wide breakfast offer should satisfy everyone even I wrote some negatives in general we can recommend this hotel and we will probably consider this hotel again for our next stay in London | 68.0 | 11.0 | 8.3 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 5 nights '] | 612 day | 51.556155 | -0.214182 | we were very happy with kind hotel stuff very good connection to public transportation hotel is nice clean and stylish even you need to pay extra for breakfast it is worth money it costs Wide breakfast offer should satisfy everyone even I wrote some negatives in general we can recommend this hotel and we will probably consider this hotel again for our next stay in London . it was little bit cold inside of our room and the only temperature regulation device was from A C which did not realy heat Wifi signal was very weak in our room We had to go to the lobby to be well conneceted from neighboring rooms you here more than you wish Noise isolation is weak | 0.0 | 0.9 | -0.7 | leisure | 0.0 | couple | 5.0 |
| 16998 | Pelzgasse 1 15 Rudolfsheim F nfhaus 1150 Vienna Austria | 37 | 3/13/2017 | 8.3 | Arthotel ANA Westbahn | Czech Republic | No Negative | 0 | 450 | i love everything I have done a lot of traveling through Europe and this is the best hotel I have found so far | 25.0 | 1.0 | 10.0 | [' Leisure trip ', ' Solo traveler ', ' Single Room ', ' Stayed 1 night '] | 143 day | 48.197951 | 16.336318 | i love everything I have done a lot of traveling through Europe and this is the best hotel I have found so far . No Negative | 0.6 | 0.9 | 0.3 | leisure | 0.0 | solo | 1.0 |
| 16999 | Taborstra e 12 02 Leopoldstadt 1020 Vienna Austria | 404 | 10/31/2016 | 9.1 | Hotel Stefanie | Czech Republic | Our room on the street side was bit noisy especially when trams were going Extra charge for parking in the hotel | 23 | 3883 | Good location within walking distance to the centre including Prater Friendly staff Great restaurant called Mochi next to the hotel | 22.0 | 2.0 | 8.3 | [' Leisure trip ', ' Couple ', ' Superior Double Room ', ' Stayed 2 nights '] | 276 day | 48.214277 | 16.380178 | Good location within walking distance to the centre including Prater Friendly staff Great restaurant called Mochi next to the hotel . Our room on the street side was bit noisy especially when trams were going Extra charge for parking in the hotel | 0.0 | 0.6 | -0.7 | leisure | 0.0 | couple | 2.0 |
Most frequent
| Hotel_Address | Additional_Number_of_Scoring | Review_Date | Average_Score | Hotel_Name | Reviewer_Nationality | Negative_Review | Review_Total_Negative_Word_Counts | Total_Number_of_Reviews | Positive_Review | Review_Total_Positive_Word_Counts | Total_Number_of_Reviews_Reviewer_Has_Given | Reviewer_Score | Tags | days_since_review | lat | lng | Review | Review_sent | Positive_Review_sent | Negative_Review_sent | Travel_type | From_Mobile | N_Persons | Stayed_Nights | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 167 rue de Rome 17th arr 75017 Paris France | 11 | 10/18/2016 | 6.8 | Villa Eugenie | Israel | No Negative | 0 | 165 | the room was very french and beautiful it was good location and I enjoyed to stay there | 18.0 | 1.0 | 9.2 | [' Leisure trip ', ' Couple ', ' Twin Room ', ' Stayed 3 nights '] | 289 day | 48.887128 | 2.314205 | the room was very french and beautiful it was good location and I enjoyed to stay there. No Negative | 0.6 | 0.9 | 0.3 | leisure | 0.0 | couple | 3.0 | 2 |
| 1 | 40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France | 228 | 2/29/2016 | 7.9 | H tel Concorde Montparnasse | Lebanon | Nothing | 3 | 2515 | Nearly everything was perfect | 5.0 | 16.0 | 9.2 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 3 nights ', ' Submitted from a mobile device '] | 521 day | 48.838108 | 2.318669 | Nearly everything was perfect. Nothing | 0.2 | 0.9 | -0.4 | leisure | 1.0 | couple | 3.0 | 2 |
| 2 | 40 Rue du Commandant Ren Mouchotte 14th arr 75014 Paris France | 228 | 9/22/2015 | 7.9 | H tel Concorde Montparnasse | Lebanon | The wifi is horrible Always something is needed in the room and it takes 24 hours before you can get it Room service is bad I ve asked for a bottle of water it came without glasses tray or ic | 41 | 2515 | The location is half an hour walking to saint germain and the staff is friendly | 16.0 | 3.0 | 7.5 | [' Leisure trip ', ' Couple ', ' Deluxe Double Room ', ' Stayed 1 night ', ' Submitted from a mobile device '] | 681 day | 48.838108 | 2.318669 | The location is half an hour walking to saint germain and the staff is friendly. The wifi is horrible Always something is needed in the room and it takes 24 hours before you can get it Room service is bad I ve asked for a bottle of water it came without glasses tray or ic | 0.0 | 0.7 | -0.7 | leisure | 1.0 | couple | 1.0 | 2 |